"""

@Time: 2021/1/27 22:24
@Author:
@File: database.py
"""
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

from config import mysql_conf
SQLALCHEMY_DATABASE_URL: str = f'mysql+mysqlconnector://root:yubin3869@localhost:3306/{mysql_conf.DB_NAME}?charset=utf8&auth_plugin=mysql_native_password'

engine = create_engine(
    SQLALCHEMY_DATABASE_URL, pool_pre_ping=True
)

SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)

Base = declarative_base()
